package com.ssish.saas.eccs.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class EmpPlanViewExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public EmpPlanViewExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andEmpPlanIdIsNull() {
            addCriterion("EMP_PLAN_ID is null");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdIsNotNull() {
            addCriterion("EMP_PLAN_ID is not null");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdEqualTo(Long value) {
            addCriterion("EMP_PLAN_ID =", value, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdNotEqualTo(Long value) {
            addCriterion("EMP_PLAN_ID <>", value, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdGreaterThan(Long value) {
            addCriterion("EMP_PLAN_ID >", value, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdGreaterThanOrEqualTo(Long value) {
            addCriterion("EMP_PLAN_ID >=", value, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdLessThan(Long value) {
            addCriterion("EMP_PLAN_ID <", value, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdLessThanOrEqualTo(Long value) {
            addCriterion("EMP_PLAN_ID <=", value, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdIn(List<Long> values) {
            addCriterion("EMP_PLAN_ID in", values, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdNotIn(List<Long> values) {
            addCriterion("EMP_PLAN_ID not in", values, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdBetween(Long value1, Long value2) {
            addCriterion("EMP_PLAN_ID between", value1, value2, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmpPlanIdNotBetween(Long value1, Long value2) {
            addCriterion("EMP_PLAN_ID not between", value1, value2, "empPlanId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdIsNull() {
            addCriterion("EMPLOYEE_ID is null");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdIsNotNull() {
            addCriterion("EMPLOYEE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdEqualTo(String value) {
            addCriterion("EMPLOYEE_ID =", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotEqualTo(String value) {
            addCriterion("EMPLOYEE_ID <>", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdGreaterThan(String value) {
            addCriterion("EMPLOYEE_ID >", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdGreaterThanOrEqualTo(String value) {
            addCriterion("EMPLOYEE_ID >=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdLessThan(String value) {
            addCriterion("EMPLOYEE_ID <", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdLessThanOrEqualTo(String value) {
            addCriterion("EMPLOYEE_ID <=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdLike(String value) {
            addCriterion("EMPLOYEE_ID like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotLike(String value) {
            addCriterion("EMPLOYEE_ID not like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdIn(List<String> values) {
            addCriterion("EMPLOYEE_ID in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotIn(List<String> values) {
            addCriterion("EMPLOYEE_ID not in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdBetween(String value1, String value2) {
            addCriterion("EMPLOYEE_ID between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotBetween(String value1, String value2) {
            addCriterion("EMPLOYEE_ID not between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNull() {
            addCriterion("END_DATE is null");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNotNull() {
            addCriterion("END_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andEndDateEqualTo(Date value) {
            addCriterion("END_DATE =", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotEqualTo(Date value) {
            addCriterion("END_DATE <>", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThan(Date value) {
            addCriterion("END_DATE >", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThanOrEqualTo(Date value) {
            addCriterion("END_DATE >=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThan(Date value) {
            addCriterion("END_DATE <", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThanOrEqualTo(Date value) {
            addCriterion("END_DATE <=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateIn(List<Date> values) {
            addCriterion("END_DATE in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotIn(List<Date> values) {
            addCriterion("END_DATE not in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateBetween(Date value1, Date value2) {
            addCriterion("END_DATE between", value1, value2, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotBetween(Date value1, Date value2) {
            addCriterion("END_DATE not between", value1, value2, "endDate");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNull() {
            addCriterion("START_DATE is null");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNotNull() {
            addCriterion("START_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andStartDateEqualTo(Date value) {
            addCriterion("START_DATE =", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotEqualTo(Date value) {
            addCriterion("START_DATE <>", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThan(Date value) {
            addCriterion("START_DATE >", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThanOrEqualTo(Date value) {
            addCriterion("START_DATE >=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThan(Date value) {
            addCriterion("START_DATE <", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThanOrEqualTo(Date value) {
            addCriterion("START_DATE <=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateIn(List<Date> values) {
            addCriterion("START_DATE in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotIn(List<Date> values) {
            addCriterion("START_DATE not in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateBetween(Date value1, Date value2) {
            addCriterion("START_DATE between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotBetween(Date value1, Date value2) {
            addCriterion("START_DATE not between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIsNull() {
            addCriterion("LASTEDIT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIsNotNull() {
            addCriterion("LASTEDIT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andLasteditDateEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE =", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE <>", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateGreaterThan(Date value) {
            addCriterion("LASTEDIT_DATE >", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateGreaterThanOrEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE >=", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateLessThan(Date value) {
            addCriterion("LASTEDIT_DATE <", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateLessThanOrEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE <=", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIn(List<Date> values) {
            addCriterion("LASTEDIT_DATE in", values, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotIn(List<Date> values) {
            addCriterion("LASTEDIT_DATE not in", values, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateBetween(Date value1, Date value2) {
            addCriterion("LASTEDIT_DATE between", value1, value2, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotBetween(Date value1, Date value2) {
            addCriterion("LASTEDIT_DATE not between", value1, value2, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysIsNull() {
            addCriterion("MC_TAKEN_DAYS is null");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysIsNotNull() {
            addCriterion("MC_TAKEN_DAYS is not null");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysEqualTo(BigDecimal value) {
            addCriterion("MC_TAKEN_DAYS =", value, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysNotEqualTo(BigDecimal value) {
            addCriterion("MC_TAKEN_DAYS <>", value, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysGreaterThan(BigDecimal value) {
            addCriterion("MC_TAKEN_DAYS >", value, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MC_TAKEN_DAYS >=", value, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysLessThan(BigDecimal value) {
            addCriterion("MC_TAKEN_DAYS <", value, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MC_TAKEN_DAYS <=", value, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysIn(List<BigDecimal> values) {
            addCriterion("MC_TAKEN_DAYS in", values, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysNotIn(List<BigDecimal> values) {
            addCriterion("MC_TAKEN_DAYS not in", values, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MC_TAKEN_DAYS between", value1, value2, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andMcTakenDaysNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MC_TAKEN_DAYS not between", value1, value2, "mcTakenDays");
            return (Criteria) this;
        }

        public Criteria andPlanCodeIsNull() {
            addCriterion("PLAN_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPlanCodeIsNotNull() {
            addCriterion("PLAN_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPlanCodeEqualTo(String value) {
            addCriterion("PLAN_CODE =", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotEqualTo(String value) {
            addCriterion("PLAN_CODE <>", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeGreaterThan(String value) {
            addCriterion("PLAN_CODE >", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PLAN_CODE >=", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeLessThan(String value) {
            addCriterion("PLAN_CODE <", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeLessThanOrEqualTo(String value) {
            addCriterion("PLAN_CODE <=", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeLike(String value) {
            addCriterion("PLAN_CODE like", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotLike(String value) {
            addCriterion("PLAN_CODE not like", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeIn(List<String> values) {
            addCriterion("PLAN_CODE in", values, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotIn(List<String> values) {
            addCriterion("PLAN_CODE not in", values, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeBetween(String value1, String value2) {
            addCriterion("PLAN_CODE between", value1, value2, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotBetween(String value1, String value2) {
            addCriterion("PLAN_CODE not between", value1, value2, "planCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNull() {
            addCriterion("USER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNotNull() {
            addCriterion("USER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andUserCodeEqualTo(String value) {
            addCriterion("USER_CODE =", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotEqualTo(String value) {
            addCriterion("USER_CODE <>", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThan(String value) {
            addCriterion("USER_CODE >", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThanOrEqualTo(String value) {
            addCriterion("USER_CODE >=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThan(String value) {
            addCriterion("USER_CODE <", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThanOrEqualTo(String value) {
            addCriterion("USER_CODE <=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLike(String value) {
            addCriterion("USER_CODE like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotLike(String value) {
            addCriterion("USER_CODE not like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeIn(List<String> values) {
            addCriterion("USER_CODE in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotIn(List<String> values) {
            addCriterion("USER_CODE not in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeBetween(String value1, String value2) {
            addCriterion("USER_CODE between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotBetween(String value1, String value2) {
            addCriterion("USER_CODE not between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNull() {
            addCriterion("ACTIVE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNotNull() {
            addCriterion("ACTIVE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagEqualTo(String value) {
            addCriterion("ACTIVE_FLAG =", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <>", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThan(String value) {
            addCriterion("ACTIVE_FLAG >", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG >=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThan(String value) {
            addCriterion("ACTIVE_FLAG <", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLike(String value) {
            addCriterion("ACTIVE_FLAG like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotLike(String value) {
            addCriterion("ACTIVE_FLAG not like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIn(List<String> values) {
            addCriterion("ACTIVE_FLAG in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotIn(List<String> values) {
            addCriterion("ACTIVE_FLAG not in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG not between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andOccurenceIsNull() {
            addCriterion("OCCURENCE is null");
            return (Criteria) this;
        }

        public Criteria andOccurenceIsNotNull() {
            addCriterion("OCCURENCE is not null");
            return (Criteria) this;
        }

        public Criteria andOccurenceEqualTo(Integer value) {
            addCriterion("OCCURENCE =", value, "occurence");
            return (Criteria) this;
        }

        public Criteria andOccurenceNotEqualTo(Integer value) {
            addCriterion("OCCURENCE <>", value, "occurence");
            return (Criteria) this;
        }

        public Criteria andOccurenceGreaterThan(Integer value) {
            addCriterion("OCCURENCE >", value, "occurence");
            return (Criteria) this;
        }

        public Criteria andOccurenceGreaterThanOrEqualTo(Integer value) {
            addCriterion("OCCURENCE >=", value, "occurence");
            return (Criteria) this;
        }

        public Criteria andOccurenceLessThan(Integer value) {
            addCriterion("OCCURENCE <", value, "occurence");
            return (Criteria) this;
        }

        public Criteria andOccurenceLessThanOrEqualTo(Integer value) {
            addCriterion("OCCURENCE <=", value, "occurence");
            return (Criteria) this;
        }

        public Criteria andOccurenceIn(List<Integer> values) {
            addCriterion("OCCURENCE in", values, "occurence");
            return (Criteria) this;
        }

        public Criteria andOccurenceNotIn(List<Integer> values) {
            addCriterion("OCCURENCE not in", values, "occurence");
            return (Criteria) this;
        }

        public Criteria andOccurenceBetween(Integer value1, Integer value2) {
            addCriterion("OCCURENCE between", value1, value2, "occurence");
            return (Criteria) this;
        }

        public Criteria andOccurenceNotBetween(Integer value1, Integer value2) {
            addCriterion("OCCURENCE not between", value1, value2, "occurence");
            return (Criteria) this;
        }

        public Criteria andActivationDateIsNull() {
            addCriterion("ACTIVATION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andActivationDateIsNotNull() {
            addCriterion("ACTIVATION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andActivationDateEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE =", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateNotEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE <>", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateGreaterThan(Date value) {
            addCriterion("ACTIVATION_DATE >", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE >=", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateLessThan(Date value) {
            addCriterion("ACTIVATION_DATE <", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateLessThanOrEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE <=", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateIn(List<Date> values) {
            addCriterion("ACTIVATION_DATE in", values, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateNotIn(List<Date> values) {
            addCriterion("ACTIVATION_DATE not in", values, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateBetween(Date value1, Date value2) {
            addCriterion("ACTIVATION_DATE between", value1, value2, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateNotBetween(Date value1, Date value2) {
            addCriterion("ACTIVATION_DATE not between", value1, value2, "activationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateIsNull() {
            addCriterion("CANCELLATION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCancellationDateIsNotNull() {
            addCriterion("CANCELLATION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCancellationDateEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE =", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateNotEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE <>", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateGreaterThan(Date value) {
            addCriterion("CANCELLATION_DATE >", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE >=", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateLessThan(Date value) {
            addCriterion("CANCELLATION_DATE <", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateLessThanOrEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE <=", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateIn(List<Date> values) {
            addCriterion("CANCELLATION_DATE in", values, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateNotIn(List<Date> values) {
            addCriterion("CANCELLATION_DATE not in", values, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateBetween(Date value1, Date value2) {
            addCriterion("CANCELLATION_DATE between", value1, value2, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateNotBetween(Date value1, Date value2) {
            addCriterion("CANCELLATION_DATE not between", value1, value2, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andRecordStatusIsNull() {
            addCriterion("RECORD_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andRecordStatusIsNotNull() {
            addCriterion("RECORD_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andRecordStatusEqualTo(Short value) {
            addCriterion("RECORD_STATUS =", value, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andRecordStatusNotEqualTo(Short value) {
            addCriterion("RECORD_STATUS <>", value, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andRecordStatusGreaterThan(Short value) {
            addCriterion("RECORD_STATUS >", value, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andRecordStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("RECORD_STATUS >=", value, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andRecordStatusLessThan(Short value) {
            addCriterion("RECORD_STATUS <", value, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andRecordStatusLessThanOrEqualTo(Short value) {
            addCriterion("RECORD_STATUS <=", value, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andRecordStatusIn(List<Short> values) {
            addCriterion("RECORD_STATUS in", values, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andRecordStatusNotIn(List<Short> values) {
            addCriterion("RECORD_STATUS not in", values, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andRecordStatusBetween(Short value1, Short value2) {
            addCriterion("RECORD_STATUS between", value1, value2, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andRecordStatusNotBetween(Short value1, Short value2) {
            addCriterion("RECORD_STATUS not between", value1, value2, "recordStatus");
            return (Criteria) this;
        }

        public Criteria andReactivationDateIsNull() {
            addCriterion("REACTIVATION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andReactivationDateIsNotNull() {
            addCriterion("REACTIVATION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andReactivationDateEqualTo(Date value) {
            addCriterion("REACTIVATION_DATE =", value, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andReactivationDateNotEqualTo(Date value) {
            addCriterion("REACTIVATION_DATE <>", value, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andReactivationDateGreaterThan(Date value) {
            addCriterion("REACTIVATION_DATE >", value, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andReactivationDateGreaterThanOrEqualTo(Date value) {
            addCriterion("REACTIVATION_DATE >=", value, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andReactivationDateLessThan(Date value) {
            addCriterion("REACTIVATION_DATE <", value, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andReactivationDateLessThanOrEqualTo(Date value) {
            addCriterion("REACTIVATION_DATE <=", value, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andReactivationDateIn(List<Date> values) {
            addCriterion("REACTIVATION_DATE in", values, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andReactivationDateNotIn(List<Date> values) {
            addCriterion("REACTIVATION_DATE not in", values, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andReactivationDateBetween(Date value1, Date value2) {
            addCriterion("REACTIVATION_DATE between", value1, value2, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andReactivationDateNotBetween(Date value1, Date value2) {
            addCriterion("REACTIVATION_DATE not between", value1, value2, "reactivationDate");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionIsNull() {
            addCriterion("EXCLUDE_EXCLUSION is null");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionIsNotNull() {
            addCriterion("EXCLUDE_EXCLUSION is not null");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionEqualTo(String value) {
            addCriterion("EXCLUDE_EXCLUSION =", value, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionNotEqualTo(String value) {
            addCriterion("EXCLUDE_EXCLUSION <>", value, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionGreaterThan(String value) {
            addCriterion("EXCLUDE_EXCLUSION >", value, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionGreaterThanOrEqualTo(String value) {
            addCriterion("EXCLUDE_EXCLUSION >=", value, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionLessThan(String value) {
            addCriterion("EXCLUDE_EXCLUSION <", value, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionLessThanOrEqualTo(String value) {
            addCriterion("EXCLUDE_EXCLUSION <=", value, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionLike(String value) {
            addCriterion("EXCLUDE_EXCLUSION like", value, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionNotLike(String value) {
            addCriterion("EXCLUDE_EXCLUSION not like", value, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionIn(List<String> values) {
            addCriterion("EXCLUDE_EXCLUSION in", values, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionNotIn(List<String> values) {
            addCriterion("EXCLUDE_EXCLUSION not in", values, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionBetween(String value1, String value2) {
            addCriterion("EXCLUDE_EXCLUSION between", value1, value2, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andExcludeExclusionNotBetween(String value1, String value2) {
            addCriterion("EXCLUDE_EXCLUSION not between", value1, value2, "excludeExclusion");
            return (Criteria) this;
        }

        public Criteria andAgentCodeIsNull() {
            addCriterion("AGENT_CODE is null");
            return (Criteria) this;
        }

        public Criteria andAgentCodeIsNotNull() {
            addCriterion("AGENT_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andAgentCodeEqualTo(String value) {
            addCriterion("AGENT_CODE =", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeNotEqualTo(String value) {
            addCriterion("AGENT_CODE <>", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeGreaterThan(String value) {
            addCriterion("AGENT_CODE >", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_CODE >=", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeLessThan(String value) {
            addCriterion("AGENT_CODE <", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeLessThanOrEqualTo(String value) {
            addCriterion("AGENT_CODE <=", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeLike(String value) {
            addCriterion("AGENT_CODE like", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeNotLike(String value) {
            addCriterion("AGENT_CODE not like", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeIn(List<String> values) {
            addCriterion("AGENT_CODE in", values, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeNotIn(List<String> values) {
            addCriterion("AGENT_CODE not in", values, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeBetween(String value1, String value2) {
            addCriterion("AGENT_CODE between", value1, value2, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeNotBetween(String value1, String value2) {
            addCriterion("AGENT_CODE not between", value1, value2, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeIsNull() {
            addCriterion("AGENCY_CODE is null");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeIsNotNull() {
            addCriterion("AGENCY_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeEqualTo(String value) {
            addCriterion("AGENCY_CODE =", value, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeNotEqualTo(String value) {
            addCriterion("AGENCY_CODE <>", value, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeGreaterThan(String value) {
            addCriterion("AGENCY_CODE >", value, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("AGENCY_CODE >=", value, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeLessThan(String value) {
            addCriterion("AGENCY_CODE <", value, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeLessThanOrEqualTo(String value) {
            addCriterion("AGENCY_CODE <=", value, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeLike(String value) {
            addCriterion("AGENCY_CODE like", value, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeNotLike(String value) {
            addCriterion("AGENCY_CODE not like", value, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeIn(List<String> values) {
            addCriterion("AGENCY_CODE in", values, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeNotIn(List<String> values) {
            addCriterion("AGENCY_CODE not in", values, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeBetween(String value1, String value2) {
            addCriterion("AGENCY_CODE between", value1, value2, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andAgencyCodeNotBetween(String value1, String value2) {
            addCriterion("AGENCY_CODE not between", value1, value2, "agencyCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeIsNull() {
            addCriterion("BROKER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeIsNotNull() {
            addCriterion("BROKER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeEqualTo(String value) {
            addCriterion("BROKER_CODE =", value, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeNotEqualTo(String value) {
            addCriterion("BROKER_CODE <>", value, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeGreaterThan(String value) {
            addCriterion("BROKER_CODE >", value, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeGreaterThanOrEqualTo(String value) {
            addCriterion("BROKER_CODE >=", value, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeLessThan(String value) {
            addCriterion("BROKER_CODE <", value, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeLessThanOrEqualTo(String value) {
            addCriterion("BROKER_CODE <=", value, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeLike(String value) {
            addCriterion("BROKER_CODE like", value, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeNotLike(String value) {
            addCriterion("BROKER_CODE not like", value, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeIn(List<String> values) {
            addCriterion("BROKER_CODE in", values, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeNotIn(List<String> values) {
            addCriterion("BROKER_CODE not in", values, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeBetween(String value1, String value2) {
            addCriterion("BROKER_CODE between", value1, value2, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andBrokerCodeNotBetween(String value1, String value2) {
            addCriterion("BROKER_CODE not between", value1, value2, "brokerCode");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumIsNull() {
            addCriterion("GROSS_PREMIUM is null");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumIsNotNull() {
            addCriterion("GROSS_PREMIUM is not null");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumEqualTo(String value) {
            addCriterion("GROSS_PREMIUM =", value, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumNotEqualTo(String value) {
            addCriterion("GROSS_PREMIUM <>", value, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumGreaterThan(String value) {
            addCriterion("GROSS_PREMIUM >", value, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumGreaterThanOrEqualTo(String value) {
            addCriterion("GROSS_PREMIUM >=", value, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumLessThan(String value) {
            addCriterion("GROSS_PREMIUM <", value, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumLessThanOrEqualTo(String value) {
            addCriterion("GROSS_PREMIUM <=", value, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumLike(String value) {
            addCriterion("GROSS_PREMIUM like", value, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumNotLike(String value) {
            addCriterion("GROSS_PREMIUM not like", value, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumIn(List<String> values) {
            addCriterion("GROSS_PREMIUM in", values, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumNotIn(List<String> values) {
            addCriterion("GROSS_PREMIUM not in", values, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumBetween(String value1, String value2) {
            addCriterion("GROSS_PREMIUM between", value1, value2, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andGrossPremiumNotBetween(String value1, String value2) {
            addCriterion("GROSS_PREMIUM not between", value1, value2, "grossPremium");
            return (Criteria) this;
        }

        public Criteria andAgentCommIsNull() {
            addCriterion("AGENT_COMM is null");
            return (Criteria) this;
        }

        public Criteria andAgentCommIsNotNull() {
            addCriterion("AGENT_COMM is not null");
            return (Criteria) this;
        }

        public Criteria andAgentCommEqualTo(String value) {
            addCriterion("AGENT_COMM =", value, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommNotEqualTo(String value) {
            addCriterion("AGENT_COMM <>", value, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommGreaterThan(String value) {
            addCriterion("AGENT_COMM >", value, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_COMM >=", value, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommLessThan(String value) {
            addCriterion("AGENT_COMM <", value, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommLessThanOrEqualTo(String value) {
            addCriterion("AGENT_COMM <=", value, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommLike(String value) {
            addCriterion("AGENT_COMM like", value, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommNotLike(String value) {
            addCriterion("AGENT_COMM not like", value, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommIn(List<String> values) {
            addCriterion("AGENT_COMM in", values, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommNotIn(List<String> values) {
            addCriterion("AGENT_COMM not in", values, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommBetween(String value1, String value2) {
            addCriterion("AGENT_COMM between", value1, value2, "agentComm");
            return (Criteria) this;
        }

        public Criteria andAgentCommNotBetween(String value1, String value2) {
            addCriterion("AGENT_COMM not between", value1, value2, "agentComm");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesIsNull() {
            addCriterion("MGMT_FEES is null");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesIsNotNull() {
            addCriterion("MGMT_FEES is not null");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesEqualTo(String value) {
            addCriterion("MGMT_FEES =", value, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesNotEqualTo(String value) {
            addCriterion("MGMT_FEES <>", value, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesGreaterThan(String value) {
            addCriterion("MGMT_FEES >", value, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesGreaterThanOrEqualTo(String value) {
            addCriterion("MGMT_FEES >=", value, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesLessThan(String value) {
            addCriterion("MGMT_FEES <", value, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesLessThanOrEqualTo(String value) {
            addCriterion("MGMT_FEES <=", value, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesLike(String value) {
            addCriterion("MGMT_FEES like", value, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesNotLike(String value) {
            addCriterion("MGMT_FEES not like", value, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesIn(List<String> values) {
            addCriterion("MGMT_FEES in", values, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesNotIn(List<String> values) {
            addCriterion("MGMT_FEES not in", values, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesBetween(String value1, String value2) {
            addCriterion("MGMT_FEES between", value1, value2, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMgmtFeesNotBetween(String value1, String value2) {
            addCriterion("MGMT_FEES not between", value1, value2, "mgmtFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesIsNull() {
            addCriterion("MCO_FEES is null");
            return (Criteria) this;
        }

        public Criteria andMcoFeesIsNotNull() {
            addCriterion("MCO_FEES is not null");
            return (Criteria) this;
        }

        public Criteria andMcoFeesEqualTo(String value) {
            addCriterion("MCO_FEES =", value, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesNotEqualTo(String value) {
            addCriterion("MCO_FEES <>", value, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesGreaterThan(String value) {
            addCriterion("MCO_FEES >", value, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesGreaterThanOrEqualTo(String value) {
            addCriterion("MCO_FEES >=", value, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesLessThan(String value) {
            addCriterion("MCO_FEES <", value, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesLessThanOrEqualTo(String value) {
            addCriterion("MCO_FEES <=", value, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesLike(String value) {
            addCriterion("MCO_FEES like", value, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesNotLike(String value) {
            addCriterion("MCO_FEES not like", value, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesIn(List<String> values) {
            addCriterion("MCO_FEES in", values, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesNotIn(List<String> values) {
            addCriterion("MCO_FEES not in", values, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesBetween(String value1, String value2) {
            addCriterion("MCO_FEES between", value1, value2, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMcoFeesNotBetween(String value1, String value2) {
            addCriterion("MCO_FEES not between", value1, value2, "mcoFees");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskIsNull() {
            addCriterion("MNRB_RISK is null");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskIsNotNull() {
            addCriterion("MNRB_RISK is not null");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskEqualTo(String value) {
            addCriterion("MNRB_RISK =", value, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskNotEqualTo(String value) {
            addCriterion("MNRB_RISK <>", value, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskGreaterThan(String value) {
            addCriterion("MNRB_RISK >", value, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskGreaterThanOrEqualTo(String value) {
            addCriterion("MNRB_RISK >=", value, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskLessThan(String value) {
            addCriterion("MNRB_RISK <", value, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskLessThanOrEqualTo(String value) {
            addCriterion("MNRB_RISK <=", value, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskLike(String value) {
            addCriterion("MNRB_RISK like", value, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskNotLike(String value) {
            addCriterion("MNRB_RISK not like", value, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskIn(List<String> values) {
            addCriterion("MNRB_RISK in", values, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskNotIn(List<String> values) {
            addCriterion("MNRB_RISK not in", values, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskBetween(String value1, String value2) {
            addCriterion("MNRB_RISK between", value1, value2, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andMnrbRiskNotBetween(String value1, String value2) {
            addCriterion("MNRB_RISK not between", value1, value2, "mnrbRisk");
            return (Criteria) this;
        }

        public Criteria andDebitNoIsNull() {
            addCriterion("DEBIT_NO is null");
            return (Criteria) this;
        }

        public Criteria andDebitNoIsNotNull() {
            addCriterion("DEBIT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andDebitNoEqualTo(Integer value) {
            addCriterion("DEBIT_NO =", value, "debitNo");
            return (Criteria) this;
        }

        public Criteria andDebitNoNotEqualTo(Integer value) {
            addCriterion("DEBIT_NO <>", value, "debitNo");
            return (Criteria) this;
        }

        public Criteria andDebitNoGreaterThan(Integer value) {
            addCriterion("DEBIT_NO >", value, "debitNo");
            return (Criteria) this;
        }

        public Criteria andDebitNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("DEBIT_NO >=", value, "debitNo");
            return (Criteria) this;
        }

        public Criteria andDebitNoLessThan(Integer value) {
            addCriterion("DEBIT_NO <", value, "debitNo");
            return (Criteria) this;
        }

        public Criteria andDebitNoLessThanOrEqualTo(Integer value) {
            addCriterion("DEBIT_NO <=", value, "debitNo");
            return (Criteria) this;
        }

        public Criteria andDebitNoIn(List<Integer> values) {
            addCriterion("DEBIT_NO in", values, "debitNo");
            return (Criteria) this;
        }

        public Criteria andDebitNoNotIn(List<Integer> values) {
            addCriterion("DEBIT_NO not in", values, "debitNo");
            return (Criteria) this;
        }

        public Criteria andDebitNoBetween(Integer value1, Integer value2) {
            addCriterion("DEBIT_NO between", value1, value2, "debitNo");
            return (Criteria) this;
        }

        public Criteria andDebitNoNotBetween(Integer value1, Integer value2) {
            addCriterion("DEBIT_NO not between", value1, value2, "debitNo");
            return (Criteria) this;
        }

        public Criteria andUnitRateIsNull() {
            addCriterion("UNIT_RATE is null");
            return (Criteria) this;
        }

        public Criteria andUnitRateIsNotNull() {
            addCriterion("UNIT_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andUnitRateEqualTo(BigDecimal value) {
            addCriterion("UNIT_RATE =", value, "unitRate");
            return (Criteria) this;
        }

        public Criteria andUnitRateNotEqualTo(BigDecimal value) {
            addCriterion("UNIT_RATE <>", value, "unitRate");
            return (Criteria) this;
        }

        public Criteria andUnitRateGreaterThan(BigDecimal value) {
            addCriterion("UNIT_RATE >", value, "unitRate");
            return (Criteria) this;
        }

        public Criteria andUnitRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("UNIT_RATE >=", value, "unitRate");
            return (Criteria) this;
        }

        public Criteria andUnitRateLessThan(BigDecimal value) {
            addCriterion("UNIT_RATE <", value, "unitRate");
            return (Criteria) this;
        }

        public Criteria andUnitRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("UNIT_RATE <=", value, "unitRate");
            return (Criteria) this;
        }

        public Criteria andUnitRateIn(List<BigDecimal> values) {
            addCriterion("UNIT_RATE in", values, "unitRate");
            return (Criteria) this;
        }

        public Criteria andUnitRateNotIn(List<BigDecimal> values) {
            addCriterion("UNIT_RATE not in", values, "unitRate");
            return (Criteria) this;
        }

        public Criteria andUnitRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UNIT_RATE between", value1, value2, "unitRate");
            return (Criteria) this;
        }

        public Criteria andUnitRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UNIT_RATE not between", value1, value2, "unitRate");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitIsNull() {
            addCriterion("CURRENT_LIMIT is null");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitIsNotNull() {
            addCriterion("CURRENT_LIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitEqualTo(BigDecimal value) {
            addCriterion("CURRENT_LIMIT =", value, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitNotEqualTo(BigDecimal value) {
            addCriterion("CURRENT_LIMIT <>", value, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitGreaterThan(BigDecimal value) {
            addCriterion("CURRENT_LIMIT >", value, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CURRENT_LIMIT >=", value, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitLessThan(BigDecimal value) {
            addCriterion("CURRENT_LIMIT <", value, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CURRENT_LIMIT <=", value, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitIn(List<BigDecimal> values) {
            addCriterion("CURRENT_LIMIT in", values, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitNotIn(List<BigDecimal> values) {
            addCriterion("CURRENT_LIMIT not in", values, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CURRENT_LIMIT between", value1, value2, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andCurrentLimitNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CURRENT_LIMIT not between", value1, value2, "currentLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitIsNull() {
            addCriterion("FAMILY_LIMIT is null");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitIsNotNull() {
            addCriterion("FAMILY_LIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitEqualTo(BigDecimal value) {
            addCriterion("FAMILY_LIMIT =", value, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitNotEqualTo(BigDecimal value) {
            addCriterion("FAMILY_LIMIT <>", value, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitGreaterThan(BigDecimal value) {
            addCriterion("FAMILY_LIMIT >", value, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FAMILY_LIMIT >=", value, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitLessThan(BigDecimal value) {
            addCriterion("FAMILY_LIMIT <", value, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FAMILY_LIMIT <=", value, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitIn(List<BigDecimal> values) {
            addCriterion("FAMILY_LIMIT in", values, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitNotIn(List<BigDecimal> values) {
            addCriterion("FAMILY_LIMIT not in", values, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FAMILY_LIMIT between", value1, value2, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andFamilyLimitNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FAMILY_LIMIT not between", value1, value2, "familyLimit");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateIsNull() {
            addCriterion("TAKE_OVER_DATE is null");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateIsNotNull() {
            addCriterion("TAKE_OVER_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateEqualTo(Date value) {
            addCriterion("TAKE_OVER_DATE =", value, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateNotEqualTo(Date value) {
            addCriterion("TAKE_OVER_DATE <>", value, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateGreaterThan(Date value) {
            addCriterion("TAKE_OVER_DATE >", value, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateGreaterThanOrEqualTo(Date value) {
            addCriterion("TAKE_OVER_DATE >=", value, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateLessThan(Date value) {
            addCriterion("TAKE_OVER_DATE <", value, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateLessThanOrEqualTo(Date value) {
            addCriterion("TAKE_OVER_DATE <=", value, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateIn(List<Date> values) {
            addCriterion("TAKE_OVER_DATE in", values, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateNotIn(List<Date> values) {
            addCriterion("TAKE_OVER_DATE not in", values, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateBetween(Date value1, Date value2) {
            addCriterion("TAKE_OVER_DATE between", value1, value2, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andTakeOverDateNotBetween(Date value1, Date value2) {
            addCriterion("TAKE_OVER_DATE not between", value1, value2, "takeOverDate");
            return (Criteria) this;
        }

        public Criteria andDependentIdIsNull() {
            addCriterion("DEPENDENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andDependentIdIsNotNull() {
            addCriterion("DEPENDENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDependentIdEqualTo(String value) {
            addCriterion("DEPENDENT_ID =", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdNotEqualTo(String value) {
            addCriterion("DEPENDENT_ID <>", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdGreaterThan(String value) {
            addCriterion("DEPENDENT_ID >", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdGreaterThanOrEqualTo(String value) {
            addCriterion("DEPENDENT_ID >=", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdLessThan(String value) {
            addCriterion("DEPENDENT_ID <", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdLessThanOrEqualTo(String value) {
            addCriterion("DEPENDENT_ID <=", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdLike(String value) {
            addCriterion("DEPENDENT_ID like", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdNotLike(String value) {
            addCriterion("DEPENDENT_ID not like", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdIn(List<String> values) {
            addCriterion("DEPENDENT_ID in", values, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdNotIn(List<String> values) {
            addCriterion("DEPENDENT_ID not in", values, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdBetween(String value1, String value2) {
            addCriterion("DEPENDENT_ID between", value1, value2, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdNotBetween(String value1, String value2) {
            addCriterion("DEPENDENT_ID not between", value1, value2, "dependentId");
            return (Criteria) this;
        }

        public Criteria andPolicyNoIsNull() {
            addCriterion("POLICY_NO is null");
            return (Criteria) this;
        }

        public Criteria andPolicyNoIsNotNull() {
            addCriterion("POLICY_NO is not null");
            return (Criteria) this;
        }

        public Criteria andPolicyNoEqualTo(String value) {
            addCriterion("POLICY_NO =", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoNotEqualTo(String value) {
            addCriterion("POLICY_NO <>", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoGreaterThan(String value) {
            addCriterion("POLICY_NO >", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoGreaterThanOrEqualTo(String value) {
            addCriterion("POLICY_NO >=", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoLessThan(String value) {
            addCriterion("POLICY_NO <", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoLessThanOrEqualTo(String value) {
            addCriterion("POLICY_NO <=", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoLike(String value) {
            addCriterion("POLICY_NO like", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoNotLike(String value) {
            addCriterion("POLICY_NO not like", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoIn(List<String> values) {
            addCriterion("POLICY_NO in", values, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoNotIn(List<String> values) {
            addCriterion("POLICY_NO not in", values, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoBetween(String value1, String value2) {
            addCriterion("POLICY_NO between", value1, value2, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoNotBetween(String value1, String value2) {
            addCriterion("POLICY_NO not between", value1, value2, "policyNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoIsNull() {
            addCriterion("MEMBER_CONTROL_NO is null");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoIsNotNull() {
            addCriterion("MEMBER_CONTROL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoEqualTo(String value) {
            addCriterion("MEMBER_CONTROL_NO =", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoNotEqualTo(String value) {
            addCriterion("MEMBER_CONTROL_NO <>", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoGreaterThan(String value) {
            addCriterion("MEMBER_CONTROL_NO >", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_CONTROL_NO >=", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoLessThan(String value) {
            addCriterion("MEMBER_CONTROL_NO <", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_CONTROL_NO <=", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoLike(String value) {
            addCriterion("MEMBER_CONTROL_NO like", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoNotLike(String value) {
            addCriterion("MEMBER_CONTROL_NO not like", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoIn(List<String> values) {
            addCriterion("MEMBER_CONTROL_NO in", values, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoNotIn(List<String> values) {
            addCriterion("MEMBER_CONTROL_NO not in", values, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoBetween(String value1, String value2) {
            addCriterion("MEMBER_CONTROL_NO between", value1, value2, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoNotBetween(String value1, String value2) {
            addCriterion("MEMBER_CONTROL_NO not between", value1, value2, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdIsNull() {
            addCriterion("PAYOR_MEMBER_ID is null");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdIsNotNull() {
            addCriterion("PAYOR_MEMBER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdEqualTo(String value) {
            addCriterion("PAYOR_MEMBER_ID =", value, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdNotEqualTo(String value) {
            addCriterion("PAYOR_MEMBER_ID <>", value, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdGreaterThan(String value) {
            addCriterion("PAYOR_MEMBER_ID >", value, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdGreaterThanOrEqualTo(String value) {
            addCriterion("PAYOR_MEMBER_ID >=", value, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdLessThan(String value) {
            addCriterion("PAYOR_MEMBER_ID <", value, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdLessThanOrEqualTo(String value) {
            addCriterion("PAYOR_MEMBER_ID <=", value, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdLike(String value) {
            addCriterion("PAYOR_MEMBER_ID like", value, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdNotLike(String value) {
            addCriterion("PAYOR_MEMBER_ID not like", value, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdIn(List<String> values) {
            addCriterion("PAYOR_MEMBER_ID in", values, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdNotIn(List<String> values) {
            addCriterion("PAYOR_MEMBER_ID not in", values, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdBetween(String value1, String value2) {
            addCriterion("PAYOR_MEMBER_ID between", value1, value2, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andPayorMemberIdNotBetween(String value1, String value2) {
            addCriterion("PAYOR_MEMBER_ID not between", value1, value2, "payorMemberId");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIsNull() {
            addCriterion("CORP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIsNotNull() {
            addCriterion("CORP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeEqualTo(String value) {
            addCriterion("CORP_CODE =", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotEqualTo(String value) {
            addCriterion("CORP_CODE <>", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThan(String value) {
            addCriterion("CORP_CODE >", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CORP_CODE >=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThan(String value) {
            addCriterion("CORP_CODE <", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThanOrEqualTo(String value) {
            addCriterion("CORP_CODE <=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLike(String value) {
            addCriterion("CORP_CODE like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotLike(String value) {
            addCriterion("CORP_CODE not like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIn(List<String> values) {
            addCriterion("CORP_CODE in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotIn(List<String> values) {
            addCriterion("CORP_CODE not in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeBetween(String value1, String value2) {
            addCriterion("CORP_CODE between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotBetween(String value1, String value2) {
            addCriterion("CORP_CODE not between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeIsNull() {
            addCriterion("ASSIGNED_CODE is null");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeIsNotNull() {
            addCriterion("ASSIGNED_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeEqualTo(String value) {
            addCriterion("ASSIGNED_CODE =", value, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeNotEqualTo(String value) {
            addCriterion("ASSIGNED_CODE <>", value, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeGreaterThan(String value) {
            addCriterion("ASSIGNED_CODE >", value, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ASSIGNED_CODE >=", value, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeLessThan(String value) {
            addCriterion("ASSIGNED_CODE <", value, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeLessThanOrEqualTo(String value) {
            addCriterion("ASSIGNED_CODE <=", value, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeLike(String value) {
            addCriterion("ASSIGNED_CODE like", value, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeNotLike(String value) {
            addCriterion("ASSIGNED_CODE not like", value, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeIn(List<String> values) {
            addCriterion("ASSIGNED_CODE in", values, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeNotIn(List<String> values) {
            addCriterion("ASSIGNED_CODE not in", values, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeBetween(String value1, String value2) {
            addCriterion("ASSIGNED_CODE between", value1, value2, "assignedCode");
            return (Criteria) this;
        }

        public Criteria andAssignedCodeNotBetween(String value1, String value2) {
            addCriterion("ASSIGNED_CODE not between", value1, value2, "assignedCode");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}